set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=300;
set hive.exec.max.dynamic.partitions.pernode=300;

insert overwrite table jms_dwd.dwd_tab_sitetakingmonitor_base_dt partition (dt)
select
recordid
,billcode
,packagecode
,scantype
,nextstation
,destination
,scanuser
,inputsite
,scantime
,inputtime
,send_deliver_user
,send_site
,pcs
,weight
,goodstype
,expresstype
,shifts
,sendflag
,sendsite
,sendtime
,problemflag
,remark
,pistolid
,scansitecode
,uploadtime
,remark3
,scanusercode
,send_deliver_usercode
,nextstationcode
,source
,remark5
,remark6
,remark4
,scansiteid
,nextstationid
,scanuserid
,send_deliver_userid
,dt
from jms_ods.tab_sitetakingmonitor
where dt = '{{ execution_date | cst_ds }}'